package pgsql;

import java.util.List;

import dao.base.api.IDTO;
import dao.connection.ConnectionBean;
import base.UsuarioDAO;

public class UsuarioDAOImpl implements UsuarioDAO {

	private ConnectionBean connectionBean;

	public void init(ConnectionBean connectionBean) {
		this.connectionBean = connectionBean;
	}

	public void createTable() throws Exception {
		String sql = "DROP TABLE IF EXISTS " + getTableName() + " CASCADE";
	    System.err.println(sql);

	    //connectionBean.createStatement().execute(sql);
	}

	@Override
	public int countAll() throws Exception {
		// TODO Auto-generated method stub
		return 0;
	}

	@Override
	public void delete(IDTO bean) throws Exception {
		// TODO Auto-generated method stub

	}

	@Override
	public String getTableName() {
		return "usuario";
	}

	@Override
	public void insert(IDTO bean) throws Exception {
		// TODO Auto-generated method stub

	}

	@Override
	public List<IDTO> listAll(int lim, int off) throws Exception {
		// TODO Auto-generated method stub
		return null;
	}

	@Override
	public List<IDTO> listAll() throws Exception {
		// TODO Auto-generated method stub
		return null;
	}

	@Override
	public List<IDTO> listBy(String key, Object val) throws Exception {
		// TODO Auto-generated method stub
		return null;
	}

	@Override
	public IDTO loadById(int id) throws Exception {
		// TODO Auto-generated method stub
		return null;
	}

	@Override
	public void update(IDTO bean) throws Exception {
		// TODO Auto-generated method stub

	}

	@Override
	public boolean validate() {
		// TODO Auto-generated method stub
		return false;
	}

}
